package com.yuyou.train.admin.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.yuyou.train.service.api.admin.entity.CommSmsVerCode;

@Mapper
public interface CommSmsVerCodeMapper {
    int deleteByPrimaryKey(String id);

    int insert(CommSmsVerCode record);

    int insertSelective(CommSmsVerCode record);

    CommSmsVerCode selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(CommSmsVerCode record);

    int updateByPrimaryKey(CommSmsVerCode record);
    
    CommSmsVerCode selectLastByMobile(String mobile);

    CommSmsVerCode selectLastByMobileAndType(@Param(value = "mobile") String mobile, @Param(value = "type") String type);

    CommSmsVerCode selectLastByMobileAndTypeAndCode(@Param(value = "mobile")String mobile, @Param(value = "type")String type, @Param(value = "code")String code);
}